Release 10.1A: OpenEdge Data Management:
SQL Reference

TO_NUMBER

Converts the given character expression to a number value.

Syntax

TO_NUMBER ( char_expression )

Example

This example illustrates the TO_NUMBER function and the SUBSTR function:

SELECT *     FROM customer     WHERE TO_NUMBER (SUBSTR (phone, 1, 3)) = 603 ;

Notes

The argument to the function must be of type CHARACTER.
The result is of type NUMERIC.
If any of the argument expressions evaluates to NULL, the result is NULL.

Compatibility

Progress extension